 
<!DOCTYPE html>
<html>
<head>
	<meta charset="UTF-8">
	<title>产品销售汇总</title>
	<link rel="stylesheet" type="text/css" href="../../rs/plugins/easyui/themes/metro/easyui.css">
	<link rel="stylesheet" type="text/css" href="../../rs/plugins/easyui/themes/icon.css">
	<link href="../../rs/css/bootstrap.min.css" rel="stylesheet">
	<link href="../../rs/plugins/datapicker/datepicker3.css" rel="stylesheet">
	<script type="text/javascript" src="../../rs/plugins/easyui/jquery.min.js"></script>
	<script type="text/javascript" src="../../rs/plugins/easyui/jquery.easyui.min.js"></script>
	<script type="text/javascript" src="../../rs/plugins/easyui/locale/easyui-lang-zh_CN.js"></script>
	<script type="text/javascript" src="../../rs/plugins/easyui/datagrid-groupview.js"></script>
	<script src="../../rs/js/jquery.cookie.js"></script>
	<script src="../../rs/js/common_qj.js"></script>
	<style>
		html,body{ margin:0px; height:100%;}
	</style>
	<?php
  		require_once('login.php');
 	?>
</head>
<body >
<table id="table" class="easyui-datagrid"  style="width:100%;height:100%;padding: 10px;"
	   data-options="
			rownumbers:true,
			singleSelect:'false',
			method:'get' ,
			toolbar:'#easyui_toolbar',
			fit:true,
			pagination: true,
			pageSize: 100,
       		pageList: [100,100,150],
			fitColumns:true,
	        showFooter:true,

	        ">
	<thead>
	<tr>
		<th data-options="field:'编号',width:30,align:'center'">编号</th>
		<th data-options="field:'条码',width:30,align:'center'">条码</th>
		<th data-options="field:'品名',width:60,left:'center'">品名</th>
		<th data-options="field:'单价',width:30,align:'center'">单价</th>
		<th data-options="field:'数量',width:30,align:'center'">数量</th>
		<th data-options="field:'金额',width:30,align:'center'">金额</th>
		<th data-options="field:'供应商',width:30,align:'center'">供应商</th>
	</tr>
	</thead>
</table>

<div id="easyui_toolbar" region="north" border="false"
	 style="height: 45px;padding: 5px 5px; ">

	<div class="col-sm-4">
		<div id="data_5">
			<div class="input-daterange input-group" id="datepicker">
				<span class="input-group-btn">
					<button onClick="expert_excel()" style="height:34px;margin-right:8px; border-radius:0px;background-color: #FFF;border: 1px solid #e5e6e7;font-size: 14px" type="button" class="btn btn-sm ">
						<i class="glyphicon glyphicon-export icon-share"></i>
					</button>
				</span>
				<input style="height:34px" type="text" class="input-sm form-control" name="start" value="" id="start" />
				<span style="background: #E5E6E7;" class="input-group-addon">到</span>
				<input style="height:34px" type="text" class="input-sm form-control" name="end" value=""  id="end"/>
			</div>
		</div>
	</div>
	<div class="col-sm-3"  >
		<div class=" draggable">
			<div class="input-group ">
				<span class="input-group-btn">
					<button style="height:34px;background-color: #FFF;border: 1px solid #e5e6e7;font-size: 14px" type="button" class="btn btn-sm ">门店号</button>
				</span>
				<select class="form-control" id="mdbh"></select>
			</div>
		</div>
	</div>

	<div class="col-sm-2"  >
		<div class=" draggable">
			<div class="input-group ">
				<span class="input-group-btn">
					<button style="height:34px;background-color: #FFF;border: 1px solid #e5e6e7;font-size: 14px" type="button" class="btn btn-sm ">供应商</button>
				</span>
				<input id="gys" class="form-control easyui-combogrid" style="width: 120px;" data-options="
					panelWidth: 400,
					collapsible:true,
					url: G_url+'prsp/getslcu?sign='+sign,
					idField: 'cuid',
					textField: 'cuname1',
					method: 'get',
					mode:'local',
					columns: [[
						{field:'ck',checkbox:true},
						{field:'cuid',title:'ID',width:40},
						{field:'cuname1',title:'供应商名称',width:40},
						{field:'cumomile',title:'联系电话',width:40,align:'right'}
					]],

					fitColumns:true,
				">

				</input>
			</div>
		</div>
	</div>


	<div id="tb" class="input-group" style="float: right; margin-right: 10px;width:200px">
		<input type="text" class="form-control" id="searchtext" placeholder="输入搜索关键字" value="">
		<div class="input-group-btn">
			<button type="button" class="btn btn-white dropdown-toggle" onclick="do_search()" style="border-radius: 0px;">
				执行
			</button>

		</div>
	</div>


</div>


<!--页面加载缓冲图标-->
<div id='loadingDiv' style="position:absolute;z-index:1000;top:0px; left:0px;
	width:100%;height:100%;background:white;text-align: center;">
	<h1 style="top: 30%; position: relative;">
		<img src="../../rs/img/loading-2.gif" /><br>
	</h1>
</div>
<script src="../../rs/plugins/datapicker/bootstrap-datepicker.js"></script>
<script>

	/*页面加载缓冲*/
	function closeLoading() {
		$("#loadingDiv").fadeOut("normal", function () {
			$(this).remove();
		});
	}
	var no;
	$.parser.onComplete = function () {
		if (no) clearTimeout(no);
		no = setTimeout(closeLoading, 1000);
	}

	var sign = URLencode($.cookie('sign'));

	//    日期插件js开始
	$("#data_5 .input-daterange").datepicker({keyboardNavigation: !1, forceParse: !1, autoclose: !0});
	var config = {
		".chosen-select": {},
		".chosen-select-deselect": {allow_single_deselect: !0},
		".chosen-select-no-single": {disable_search_threshold: 10},
		".chosen-select-no-results": {no_results_text: "Oops, nothing found!"},
		".chosen-select-width": {width: "95%"}
	};
	//    日期插件js结束




	$(function(){
		if(sign==="undefined"){
			window.location.href = "login.html";
		}
		if ((new Date()).format('dd')==01)
		{var start1=(new Date()).format('dd');
		}else{
			var start1=(new Date()).format('dd')-1;
		}
		var start1=start1.toString();
		if (start1.length == 1) {
			start1 = '0' + start1;
		}
		var start=(new Date()).format('yyyy-MM-'+start1);
		var end=(new Date()).format( 'yyyy-MM-dd');
		$('#start').val(start);
		$('#end').val(end);
		/*f_sheard();*/
		sel_mdbh();

	});




	//判断用户权限&加载数据
	function f_sheard(){
		var rq1=$('#start').val();
		var rq2=$('#end').val();
		$.ajax({
			type: "post",
			url:G_url+'repo/shopxshz',
			data:'sign=' + sign+"&rq1="+rq1+"&rq2="+rq2+"&shop="+"all",
			dataType: "json",
			success: function (data){
				$('#table').datagrid({
					data: data
				});
			},
			error: function (XMLHttpRequest, textStatus, errorThrown) {
			}
		});
	}







	function do_search(){
	 var rq1=$('#start').val();
	 var rq2=$('#end').val();
	 var shop=$('#mdbh').val();
	 var spid=$('#gys').combogrid('getValue');
	 var s=$('#searchtext').val();
	 layer.msg('数据加载中...', {icon: 16, time: 200000, shade: [0.1, 'black']});
	 $.ajax({
		 type: "post",
		 url:G_url+'repo/shopxshz?sign='+sign,
		 data:"rq1="+rq1+"&rq2="+rq2+"&shop="+shop+"&spid="+spid+"&s="+s,
		 dataType: "json",
		 success: function (result){
			 $('#table').datagrid({loadFilter:pagerFilter}).datagrid({
			 data: result
			 });
			 layer.closeAll();
		 },
		 error: function (XMLHttpRequest, textStatus, errorThrown) {
		 alert(errorThrown);
		 }
	 });
	 }

  function sel_mdbh(){
	  $.ajax({
		  type: "post",
		  url:G_url+'repo/getshop',
		  data:'sign='+sign,
		  dataType: "json",
		  success: function (data){

			  //给门店编号做循环
			  var ff = data.rows;
			  var html = '';
			  $.each(ff, function (a, b) {//直接取出json的prolist做each循环.
				  html += "<option value='"+b.shopid+"'>" + b.shopname + "</option>";//拼接字符串.
			  });
			  $("#mdbh").append(html);
		  },
		  error: function (XMLHttpRequest, textStatus, errorThrown) {
		  }
	  });
  }


	function pagerFilter(data){
		if (typeof data.length == 'number' && typeof data.splice == 'function'){	// is array
			data = {
				total: data.length,
				rows: data
			}
		}
		var dg = $(this);
		var opts = dg.datagrid('options');
		var pager = dg.datagrid('getPager');
		pager.pagination({
			onSelectPage:function(pageNum, pageSize){
				opts.pageNumber = pageNum;
				opts.pageSize = pageSize;
				pager.pagination('refresh',{
					pageNumber:pageNum,
					pageSize:pageSize
				});
				dg.datagrid('loadData',data);
			}
		});
		if (!data.originalRows){
			data.originalRows = (data.rows);
		}
		var start = (opts.pageNumber-1)*parseInt(opts.pageSize);
		var end = start + parseInt(opts.pageSize);
		data.rows = (data.originalRows.slice(start, end));
		return data;
	}



	function expert_excel(){
		var newtable=$(".datagrid-view2").find(".datagrid-btable").append('<table id="newtable">' +$("#table").html()+ '</table>');
		newtable.tableExport({
			type:'excel',
			separator:';',
			escape:'false'
		});
		$("#newtable").remove();
	}
</script>

<script src="../../rs/plugins/layer/layer.min.js"></script>
<script src="../../rs/js/bootstrap.js"></script>
<script src="../../rs/plugins/md5.js"></script>
<script src="../../rs/plugins/tableExport.js"></script>
</body>
</html>
